create or replace procedure pro_Insert_Row(TableName varchar2,ColValue varchar2) is
begin
execute immediate 'insert into '||TableName||' values '||'('||q'{'}'||ColValue||q'{'}'||')' ;
end;
/

--------Quoto Operator (q)-------
Many SQL statements use character literals in expressions or conditions. If the literal itself
contains a single quotation mark, you can use the quote (q) operator and choose your own
quotation mark delimiter
You can choose any convenient delimiter, single-byte or multibyte, or any of the following
character pairs: [ ], { }, ( ), or < >.
Example:"select q'{'TROYMAN'}' from dual" the result is 'TROYMAN'.
